CREATE TABLE [dbo].[JOL_SurveyManagement_Items]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[survey] [int] NULL,
[question] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[type] [bit] NULL,
[option1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[option2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[option3] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[option4] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[option5] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[option6] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[add_time] [smalldatetime] NULL,
[user_add] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[update_time] [smalldatetime] NULL,
[user_update] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'选项1', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Items', 'COLUMN', N'option1'
GO
EXEC sp_addextendedproperty N'MS_Description', N'对应调查的id', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Items', 'COLUMN', N'survey'
GO
EXEC sp_addextendedproperty N'MS_Description', N'问题的类型：true为单选，false为不定选', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Items', 'COLUMN', N'type'
GO
